Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 260975 |
| Missing cells | 628503 |
| Missing cells (%) | 10.0% |
| Duplicate rows | 61995 |
| Duplicate rows (%) | 23.8% |
| Total size in memory | 49.8 MiB |
| Average record size in memory | 200.0 B |
Variable types
| Text | 10 |
|---|---|
| Numeric | 5 |
| Unsupported | 2 |
| Categorical | 7 |
aff_code has constant value "national" | Constant |
page_channel has constant value "shopping" | Constant |
| Dataset has 61995 (23.8%) duplicate rows | Duplicates |
drivetrain is highly imbalanced (52.6%) | Imbalance |
fuel_type is highly imbalanced (81.1%) | Imbalance |
msrp has 63798 (24.4%) missing values | Missing |
local_zone has 260975 (100.0%) missing values | Missing |
interior_color has 13419 (5.1%) missing values | Missing |
price_badge has 260975 (100.0%) missing values | Missing |
trim has 4179 (1.6%) missing values | Missing |
dealer_name has 2693 (1.0%) missing values | Missing |
dealer_zip has 2693 (1.0%) missing values | Missing |
mileage has 5943 (2.3%) missing values | Missing |
cat has 4057 (1.6%) missing values | Missing |
exterior_color has 3285 (1.3%) missing values | Missing |
price is highly skewed (γ1 = 359.5290972) | Skewed |
local_zone is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
price_badge is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
msrp has 65198 (25.0%) zeros | Zeros |
mileage has 10145 (3.9%) zeros | Zeros |
Reproduction
| Analysis started | 2024-07-21 13:40:25.622318 |
|---|---|
| Analysis finished | 2024-07-21 13:40:39.809800 |
| Duration | 14.19 seconds |
| Software version | ydata-profiling vv4.9.0 |
| Download configuration | config.json |
listing_id
Text
| Distinct | 93439 |
|---|---|
| Distinct (%) | 35.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Characters and Unicode
| Total characters | 9395100 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 33719 ? |
|---|---|
| Unique (%) | 12.9% |
Sample
| 1st row | 2f77722f-3a80-4960-bd04-4859b4df975e |
|---|---|
| 2nd row | 067f9671-3672-4d0a-afe8-110b905bed3a |
| 3rd row | 0a24aeeb-112c-4a6f-b932-07504e82dacb |
| 4th row | 2636cae0-4081-4ce3-8940-5687e8ada129 |
| 5th row | b443a216-8ea4-4e1c-b5f3-a6210d6f95e9 |
| Value | Count | Frequency (%) |
| 743d3e93-bfdd-4df8-ac72-be6bba76ca70 | 40 | < 0.1% |
| 8959974d-c353-40a0-ad49-af524e14d9ed | 39 | < 0.1% |
| ef89f280-8bee-44f7-b6a7-836c7f51dcc3 | 38 | < 0.1% |
| 2acb94ed-1ed9-4ff4-97c7-58dd23794659 | 38 | < 0.1% |
| 0da5d4d7-714c-43d0-9cf7-c0e57895fbf8 | 38 | < 0.1% |
| 7a580c37-c5ea-4e7a-a1ac-7c78d44dde2a | 38 | < 0.1% |
| 8bc4fa9b-f2cc-4b16-b705-85d3a138475f | 38 | < 0.1% |
| b7e64e4f-b5f2-4c00-a6f2-40bb9150c2d4 | 38 | < 0.1% |
| 41ce1607-5d74-4d82-a6e4-75fa06f00e44 | 37 | < 0.1% |
| 97e39f52-395b-4561-82f0-9a7f5307d44d | 37 | < 0.1% |
| Other values (93429) | 260594 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 1043900 | 11.1% |
| 4 | 749171 | 8.0% |
| b | 556422 | 5.9% |
| 8 | 555463 | 5.9% |
| a | 554473 | 5.9% |
| 9 | 552933 | 5.9% |
| 1 | 491443 | 5.2% |
| 3 | 491438 | 5.2% |
| e | 490317 | 5.2% |
| d | 489810 | 5.2% |
| Other values (7) | 3419730 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9395100 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 1043900 | 11.1% |
| 4 | 749171 | 8.0% |
| b | 556422 | 5.9% |
| 8 | 555463 | 5.9% |
| a | 554473 | 5.9% |
| 9 | 552933 | 5.9% |
| 1 | 491443 | 5.2% |
| 3 | 491438 | 5.2% |
| e | 490317 | 5.2% |
| d | 489810 | 5.2% |
| Other values (7) | 3419730 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9395100 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 1043900 | 11.1% |
| 4 | 749171 | 8.0% |
| b | 556422 | 5.9% |
| 8 | 555463 | 5.9% |
| a | 554473 | 5.9% |
| 9 | 552933 | 5.9% |
| 1 | 491443 | 5.2% |
| 3 | 491438 | 5.2% |
| e | 490317 | 5.2% |
| d | 489810 | 5.2% |
| Other values (7) | 3419730 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9395100 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 1043900 | 11.1% |
| 4 | 749171 | 8.0% |
| b | 556422 | 5.9% |
| 8 | 555463 | 5.9% |
| a | 554473 | 5.9% |
| 9 | 552933 | 5.9% |
| 1 | 491443 | 5.2% |
| 3 | 491438 | 5.2% |
| e | 490317 | 5.2% |
| d | 489810 | 5.2% |
| Other values (7) | 3419730 |
msrp
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 16080 |
|---|---|
| Distinct (%) | 8.2% |
| Missing | 63798 |
| Missing (%) | 24.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 34935.524 |
| Minimum | 0 |
|---|---|
| Maximum | 489716 |
| Zeros | 65198 |
| Zeros (%) | 25.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 34633 |
| Q3 | 54395 |
| 95-th percentile | 86890 |
| Maximum | 489716 |
| Range | 489716 |
| Interquartile range (IQR) | 54395 |
Descriptive statistics
| Standard deviation | 32417.017 |
|---|---|
| Coefficient of variation (CV) | 0.92790985 |
| Kurtosis | 5.6903852 |
| Mean | 34935.524 |
| Median Absolute Deviation (MAD) | 26364 |
| Skewness | 1.3293331 |
| Sum | 6.8884818 × 109 |
| Variance | 1.050863 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 65198 | |
| 54595 | 636 | 0.2% |
| 46465 | 574 | 0.2% |
| 44115 | 543 | 0.2% |
| 34085 | 402 | 0.2% |
| 32189 | 305 | 0.1% |
| 36926 | 281 | 0.1% |
| 35975 | 276 | 0.1% |
| 33160 | 262 | 0.1% |
| 32360 | 255 | 0.1% |
| Other values (16070) | 128445 | |
| (Missing) | 63798 |
| Value | Count | Frequency (%) |
| 0 | 65198 | |
| 4895 | 3 | < 0.1% |
| 5895 | 1 | < 0.1% |
| 5985 | 1 | < 0.1% |
| 5991 | 1 | < 0.1% |
| 5995 | 2 | < 0.1% |
| 6000 | 3 | < 0.1% |
| 6188 | 2 | < 0.1% |
| 6493 | 4 | < 0.1% |
| 6495 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 489716 | 1 | < 0.1% |
| 405750 | 2 | < 0.1% |
| 367820 | 3 | |
| 359785 | 3 | |
| 353345 | 1 | < 0.1% |
| 344375 | 4 | |
| 335000 | 1 | < 0.1% |
| 330000 | 2 | < 0.1% |
| 329486 | 7 | |
| 326445 | 5 |
year
Real number (ℝ)
| Distinct | 71 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2020.2839 |
| Minimum | 1936 |
|---|---|
| Maximum | 2025 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 1936 |
|---|---|
| 5-th percentile | 2008 |
| Q1 | 2019 |
| median | 2023 |
| Q3 | 2024 |
| 95-th percentile | 2024 |
| Maximum | 2025 |
| Range | 89 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 6.4423533 |
|---|---|
| Coefficient of variation (CV) | 0.0031888356 |
| Kurtosis | 20.134154 |
| Mean | 2020.2839 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -3.5307972 |
| Sum | 5.2724359 × 108 |
| Variance | 41.503916 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2024 | 120367 | |
| 2021 | 19682 | 7.5% |
| 2023 | 19624 | 7.5% |
| 2020 | 11983 | 4.6% |
| 2022 | 11899 | 4.6% |
| 2019 | 10039 | 3.8% |
| 2018 | 9115 | 3.5% |
| 2017 | 7966 | 3.1% |
| 2016 | 6970 | 2.7% |
| 2015 | 5716 | 2.2% |
| Other values (61) | 37614 | 14.4% |
| Value | Count | Frequency (%) |
| 1936 | 7 | < 0.1% |
| 1941 | 8 | < 0.1% |
| 1953 | 1 | < 0.1% |
| 1957 | 65 | |
| 1959 | 44 | |
| 1960 | 44 | |
| 1961 | 10 | < 0.1% |
| 1962 | 2 | < 0.1% |
| 1963 | 16 | < 0.1% |
| 1964 | 28 |
| Value | Count | Frequency (%) |
| 2025 | 4794 | 1.8% |
| 2024 | 120367 | |
| 2023 | 19624 | 7.5% |
| 2022 | 11899 | 4.6% |
| 2021 | 19682 | 7.5% |
| 2020 | 11983 | 4.6% |
| 2019 | 10039 | 3.8% |
| 2018 | 9115 | 3.5% |
| 2017 | 7966 | 3.1% |
| 2016 | 6970 | 2.7% |
canonical_mmty
Text
| Distinct | 16713 |
|---|---|
| Distinct (%) | 6.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
Length
| Max length | 102 |
|---|---|
| Median length | 92 |
| Mean length | 28.227248 |
| Min length | 11 |
Characters and Unicode
| Total characters | 7366606 |
|---|---|
| Distinct characters | 81 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2469 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | Chevrolet:Blazer EV:RS:2024 |
|---|---|
| 2nd row | RAM:ProMaster 2500:High Roof:2024 |
| 3rd row | Mercedes-Benz:Sprinter 2500:High Roof:2024 |
| 4th row | Honda:CR-V:EX:2024 |
| 5th row | Chevrolet:Equinox:LS:2024 |
| Value | Count | Frequency (%) |
| jeep:grand | 6340 | 1.3% |
| s | 4930 | 1.0% |
| premium | 4449 | 0.9% |
| se:2024 | 3985 | 0.8% |
| chevrolet:silverado | 3925 | 0.8% |
| ram:promaster | 3594 | 0.7% |
| mercedes-benz:amg | 3481 | 0.7% |
| mercedes-benz:sprinter | 3375 | 0.7% |
| cherokee | 3107 | 0.6% |
| roof:2024 | 2976 | 0.6% |
| Other values (14924) | 466916 |
Most occurring characters
| Value | Count | Frequency (%) |
| : | 782928 | 10.6% |
| 2 | 500085 | 6.8% |
| e | 482194 | 6.5% |
| 0 | 394043 | 5.3% |
| a | 350510 | 4.8% |
| r | 337781 | 4.6% |
| o | 273351 | 3.7% |
| i | 261702 | 3.6% |
| 245589 | 3.3% | |
| n | 213922 | 2.9% |
| Other values (71) | 3524501 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7366606 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| : | 782928 | 10.6% |
| 2 | 500085 | 6.8% |
| e | 482194 | 6.5% |
| 0 | 394043 | 5.3% |
| a | 350510 | 4.8% |
| r | 337781 | 4.6% |
| o | 273351 | 3.7% |
| i | 261702 | 3.6% |
| 245589 | 3.3% | |
| n | 213922 | 2.9% |
| Other values (71) | 3524501 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7366606 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| : | 782928 | 10.6% |
| 2 | 500085 | 6.8% |
| e | 482194 | 6.5% |
| 0 | 394043 | 5.3% |
| a | 350510 | 4.8% |
| r | 337781 | 4.6% |
| o | 273351 | 3.7% |
| i | 261702 | 3.6% |
| 245589 | 3.3% | |
| n | 213922 | 2.9% |
| Other values (71) | 3524501 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7366606 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| : | 782928 | 10.6% |
| 2 | 500085 | 6.8% |
| e | 482194 | 6.5% |
| 0 | 394043 | 5.3% |
| a | 350510 | 4.8% |
| r | 337781 | 4.6% |
| o | 273351 | 3.7% |
| i | 261702 | 3.6% |
| 245589 | 3.3% | |
| n | 213922 | 2.9% |
| Other values (71) | 3524501 |
model
Text
| Distinct | 1159 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
Length
| Max length | 28 |
|---|---|
| Median length | 25 |
| Mean length | 7.2717847 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1897754 |
|---|---|
| Distinct characters | 71 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 19 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Blazer EV |
|---|---|
| 2nd row | ProMaster 2500 |
| 3rd row | Sprinter 2500 |
| 4th row | CR-V |
| 5th row | Equinox |
| Value | Count | Frequency (%) |
| 1500 | 8445 | 2.4% |
| cherokee | 7220 | 2.0% |
| 2500 | 7173 | 2.0% |
| grand | 6847 | 1.9% |
| escape | 4591 | 1.3% |
| hybrid | 4019 | 1.1% |
| silverado | 3925 | 1.1% |
| sport | 3847 | 1.1% |
| compass | 3600 | 1.0% |
| promaster | 3594 | 1.0% |
| Other values (935) | 299634 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 140261 | 7.4% |
| r | 138199 | 7.3% |
| e | 132075 | 7.0% |
| o | 97651 | 5.1% |
| 91920 | 4.8% | |
| n | 81160 | 4.3% |
| 0 | 81133 | 4.3% |
| i | 71312 | 3.8% |
| t | 68421 | 3.6% |
| s | 63380 | 3.3% |
| Other values (61) | 932242 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1897754 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 140261 | 7.4% |
| r | 138199 | 7.3% |
| e | 132075 | 7.0% |
| o | 97651 | 5.1% |
| 91920 | 4.8% | |
| n | 81160 | 4.3% |
| 0 | 81133 | 4.3% |
| i | 71312 | 3.8% |
| t | 68421 | 3.6% |
| s | 63380 | 3.3% |
| Other values (61) | 932242 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1897754 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 140261 | 7.4% |
| r | 138199 | 7.3% |
| e | 132075 | 7.0% |
| o | 97651 | 5.1% |
| 91920 | 4.8% | |
| n | 81160 | 4.3% |
| 0 | 81133 | 4.3% |
| i | 71312 | 3.8% |
| t | 68421 | 3.6% |
| s | 63380 | 3.3% |
| Other values (61) | 932242 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1897754 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 140261 | 7.4% |
| r | 138199 | 7.3% |
| e | 132075 | 7.0% |
| o | 97651 | 5.1% |
| 91920 | 4.8% | |
| n | 81160 | 4.3% |
| 0 | 81133 | 4.3% |
| i | 71312 | 3.8% |
| t | 68421 | 3.6% |
| s | 63380 | 3.3% |
| Other values (61) | 932242 |
local_zone
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 260975 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 4.0 MiB |
interior_color
Text
MISSING 
| Distinct | 2970 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 13419 |
| Missing (%) | 5.1% |
| Memory size | 4.0 MiB |
Length
| Max length | 94 |
|---|---|
| Median length | 5 |
| Mean length | 7.7821503 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1926518 |
|---|---|
| Distinct characters | 74 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 594 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | Black |
|---|---|
| 2nd row | Black |
| 3rd row | Gray |
| 4th row | Medium Ash Gray |
| 5th row | Pearl Beige |
| Value | Count | Frequency (%) |
| black | 138507 | |
| gray | 23827 | 6.8% |
| ebony | 17981 | 5.1% |
| jet | 17491 | 5.0% |
| charcoal | 11054 | 3.2% |
| beige | 7150 | 2.0% |
| red | 6082 | 1.7% |
| dark | 5227 | 1.5% |
| medium | 5019 | 1.4% |
| 4382 | 1.3% | |
| Other values (1754) | 112864 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 252176 | |
| l | 183504 | 9.5% |
| c | 174673 | 9.1% |
| B | 164929 | 8.6% |
| k | 153088 | 7.9% |
| 102064 | 5.3% | |
| e | 100057 | 5.2% |
| r | 81079 | 4.2% |
| o | 66661 | 3.5% |
| t | 63100 | 3.3% |
| Other values (64) | 585187 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1926518 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 252176 | |
| l | 183504 | 9.5% |
| c | 174673 | 9.1% |
| B | 164929 | 8.6% |
| k | 153088 | 7.9% |
| 102064 | 5.3% | |
| e | 100057 | 5.2% |
| r | 81079 | 4.2% |
| o | 66661 | 3.5% |
| t | 63100 | 3.3% |
| Other values (64) | 585187 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1926518 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 252176 | |
| l | 183504 | 9.5% |
| c | 174673 | 9.1% |
| B | 164929 | 8.6% |
| k | 153088 | 7.9% |
| 102064 | 5.3% | |
| e | 100057 | 5.2% |
| r | 81079 | 4.2% |
| o | 66661 | 3.5% |
| t | 63100 | 3.3% |
| Other values (64) | 585187 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1926518 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 252176 | |
| l | 183504 | 9.5% |
| c | 174673 | 9.1% |
| B | 164929 | 8.6% |
| k | 153088 | 7.9% |
| 102064 | 5.3% | |
| e | 100057 | 5.2% |
| r | 81079 | 4.2% |
| o | 66661 | 3.5% |
| t | 63100 | 3.3% |
| Other values (64) | 585187 |
aff_code
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| national |
|---|
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 2087800 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | national |
|---|---|
| 2nd row | national |
| 3rd row | national |
| 4th row | national |
| 5th row | national |
Common Values
| Value | Count | Frequency (%) |
| national | 260975 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| national | 260975 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 521950 | |
| a | 521950 | |
| t | 260975 | |
| i | 260975 | |
| o | 260975 | |
| l | 260975 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2087800 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 521950 | |
| a | 521950 | |
| t | 260975 | |
| i | 260975 | |
| o | 260975 | |
| l | 260975 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2087800 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 521950 | |
| a | 521950 | |
| t | 260975 | |
| i | 260975 | |
| o | 260975 | |
| l | 260975 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2087800 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 521950 | |
| a | 521950 | |
| t | 260975 | |
| i | 260975 | |
| o | 260975 | |
| l | 260975 |
price
Real number (ℝ)
SKEWED 
| Distinct | 38130 |
|---|---|
| Distinct (%) | 14.7% |
| Missing | 1548 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46273.637 |
| Minimum | 0 |
|---|---|
| Maximum | 4.49954 × 108 |
| Zeros | 96 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9995 |
| Q1 | 23328 |
| median | 34487 |
| Q3 | 51664 |
| 95-th percentile | 92800 |
| Maximum | 4.49954 × 108 |
| Range | 4.49954 × 108 |
| Interquartile range (IQR) | 28336 |
Descriptive statistics
| Standard deviation | 1249929.7 |
|---|---|
| Coefficient of variation (CV) | 27.011701 |
| Kurtosis | 129410.03 |
| Mean | 46273.637 |
| Median Absolute Deviation (MAD) | 13601 |
| Skewness | 359.5291 |
| Sum | 1.2004631 × 1010 |
| Variance | 1.5623242 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9995 | 660 | 0.3% |
| 18995 | 649 | 0.2% |
| 19995 | 607 | 0.2% |
| 16995 | 597 | 0.2% |
| 15995 | 589 | 0.2% |
| 17995 | 582 | 0.2% |
| 14995 | 573 | 0.2% |
| 12995 | 560 | 0.2% |
| 13995 | 554 | 0.2% |
| 21995 | 529 | 0.2% |
| Other values (38120) | 253527 | |
| (Missing) | 1548 | 0.6% |
| Value | Count | Frequency (%) |
| 0 | 96 | |
| 32 | 1 | < 0.1% |
| 1234 | 3 | < 0.1% |
| 1500 | 25 | < 0.1% |
| 1700 | 2 | < 0.1% |
| 1750 | 3 | < 0.1% |
| 1900 | 6 | < 0.1% |
| 1995 | 6 | < 0.1% |
| 2000 | 33 | < 0.1% |
| 2095 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 449953995 | 2 | < 0.1% |
| 1699800 | 36 | |
| 1099999 | 5 | < 0.1% |
| 934900 | 2 | < 0.1% |
| 929895 | 12 | < 0.1% |
| 869800 | 7 | < 0.1% |
| 829800 | 9 | < 0.1% |
| 749900 | 3 | < 0.1% |
| 709800 | 20 | |
| 649900 | 3 | < 0.1% |
price_badge
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 260975 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 4.0 MiB |
trim
Text
MISSING 
| Distinct | 3353 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 4179 |
| Missing (%) | 1.6% |
| Memory size | 4.0 MiB |
Length
| Max length | 77 |
|---|---|
| Median length | 69 |
| Mean length | 7.8425637 |
| Min length | 1 |
Characters and Unicode
| Total characters | 2013939 |
|---|---|
| Distinct characters | 81 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 446 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | RS |
|---|---|
| 2nd row | High Roof |
| 3rd row | High Roof |
| 4th row | EX |
| 5th row | LS |
| Value | Count | Frequency (%) |
| base | 25056 | 6.2% |
| premium | 15644 | 3.8% |
| s | 14291 | 3.5% |
| limited | 12444 | 3.1% |
| se | 11998 | 3.0% |
| sport | 9192 | 2.3% |
| sel | 9018 | 2.2% |
| 4matic | 8860 | 2.2% |
| plus | 7035 | 1.7% |
| 2.0t | 6286 | 1.5% |
| Other values (1709) | 286741 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 161162 | 8.0% |
| 149255 | 7.4% | |
| i | 120886 | 6.0% |
| r | 102626 | 5.1% |
| S | 89945 | 4.5% |
| a | 89847 | 4.5% |
| L | 80364 | 4.0% |
| T | 75875 | 3.8% |
| t | 66662 | 3.3% |
| o | 63432 | 3.1% |
| Other values (71) | 1013885 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2013939 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 161162 | 8.0% |
| 149255 | 7.4% | |
| i | 120886 | 6.0% |
| r | 102626 | 5.1% |
| S | 89945 | 4.5% |
| a | 89847 | 4.5% |
| L | 80364 | 4.0% |
| T | 75875 | 3.8% |
| t | 66662 | 3.3% |
| o | 63432 | 3.1% |
| Other values (71) | 1013885 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2013939 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 161162 | 8.0% |
| 149255 | 7.4% | |
| i | 120886 | 6.0% |
| r | 102626 | 5.1% |
| S | 89945 | 4.5% |
| a | 89847 | 4.5% |
| L | 80364 | 4.0% |
| T | 75875 | 3.8% |
| t | 66662 | 3.3% |
| o | 63432 | 3.1% |
| Other values (71) | 1013885 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2013939 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 161162 | 8.0% |
| 149255 | 7.4% | |
| i | 120886 | 6.0% |
| r | 102626 | 5.1% |
| S | 89945 | 4.5% |
| a | 89847 | 4.5% |
| L | 80364 | 4.0% |
| T | 75875 | 3.8% |
| t | 66662 | 3.3% |
| o | 63432 | 3.1% |
| Other values (71) | 1013885 |
drivetrain
Categorical
IMBALANCE 
| Distinct | 18 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1443 |
| Missing (%) | 0.6% |
| Memory size | 4.0 MiB |
| All-wheel Drive | |
|---|---|
| Front-wheel Drive | |
| Four-wheel Drive | |
| Rear-wheel Drive | |
| AWD | 3388 |
| Other values (13) | 3271 |
Length
| Max length | 58 |
|---|---|
| Median length | 17 |
| Mean length | 15.431134 |
| Min length | 3 |
Characters and Unicode
| Total characters | 4004873 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | All-wheel Drive |
|---|---|
| 2nd row | Front-wheel Drive |
| 3rd row | Rear-wheel Drive |
| 4th row | Front-wheel Drive |
| 5th row | Front-wheel Drive |
Common Values
| Value | Count | Frequency (%) |
| All-wheel Drive | 121472 | |
| Front-wheel Drive | 55003 | |
| Four-wheel Drive | 47188 | 18.1% |
| Rear-wheel Drive | 29210 | 11.2% |
| AWD | 3388 | 1.3% |
| FWD | 1281 | 0.5% |
| Unknown | 899 | 0.3% |
| 4WD | 666 | 0.3% |
| RWD | 273 | 0.1% |
| All Wheel Drive | 51 | < 0.1% |
| Other values (8) | 101 | < 0.1% |
| (Missing) | 1443 | 0.6% |
Length
| Value | Count | Frequency (%) |
| drive | 253010 | |
| all-wheel | 121476 | |
| front-wheel | 55003 | 10.7% |
| four-wheel | 47188 | 9.2% |
| rear-wheel | 29210 | 5.7% |
| awd | 3388 | 0.7% |
| fwd | 1281 | 0.2% |
| unknown | 899 | 0.2% |
| 4wd | 666 | 0.1% |
| rwd | 273 | 0.1% |
| Other values (13) | 286 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 788274 | |
| l | 496066 | |
| r | 384494 | |
| D | 258625 | 6.5% |
| w | 253773 | 6.3% |
| 253148 | 6.3% | |
| i | 253017 | 6.3% |
| h | 253011 | 6.3% |
| v | 253010 | 6.3% |
| - | 252878 | 6.3% |
| Other values (26) | 558577 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4004873 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 788274 | |
| l | 496066 | |
| r | 384494 | |
| D | 258625 | 6.5% |
| w | 253773 | 6.3% |
| 253148 | 6.3% | |
| i | 253017 | 6.3% |
| h | 253011 | 6.3% |
| v | 253010 | 6.3% |
| - | 252878 | 6.3% |
| Other values (26) | 558577 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4004873 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 788274 | |
| l | 496066 | |
| r | 384494 | |
| D | 258625 | 6.5% |
| w | 253773 | 6.3% |
| 253148 | 6.3% | |
| i | 253017 | 6.3% |
| h | 253011 | 6.3% |
| v | 253010 | 6.3% |
| - | 252878 | 6.3% |
| Other values (26) | 558577 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4004873 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 788274 | |
| l | 496066 | |
| r | 384494 | |
| D | 258625 | 6.5% |
| w | 253773 | 6.3% |
| 253148 | 6.3% | |
| i | 253017 | 6.3% |
| h | 253011 | 6.3% |
| v | 253010 | 6.3% |
| - | 252878 | 6.3% |
| Other values (26) | 558577 |
dealer_name
Text
MISSING 
| Distinct | 952 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 2693 |
| Missing (%) | 1.0% |
| Memory size | 4.0 MiB |
Length
| Max length | 86 |
|---|---|
| Median length | 56 |
| Mean length | 23.972154 |
| Min length | 6 |
Characters and Unicode
| Total characters | 6191576 |
|---|---|
| Distinct characters | 69 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 383 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Castle Rock Chevrolet GMC |
|---|---|
| 2nd row | New Smyrna Chrysler Jeep Dodge RAM |
| 3rd row | Mercedes-Benz of Farmington |
| 4th row | Kingman Honda |
| 5th row | McSweeney Chevrolet GMC Clanton |
| Value | Count | Frequency (%) |
| of | 80208 | 8.4% |
| dodge | 23981 | 2.5% |
| chrysler | 23363 | 2.5% |
| jeep | 23356 | 2.5% |
| ram | 23353 | 2.5% |
| chicago | 23165 | 2.4% |
| auto | 22763 | 2.4% |
| ford | 21291 | 2.2% |
| chevrolet | 18413 | 1.9% |
| motors | 15147 | 1.6% |
| Other values (991) | 676561 |
Most occurring characters
| Value | Count | Frequency (%) |
| 693319 | 11.2% | |
| e | 502694 | 8.1% |
| o | 487649 | 7.9% |
| a | 411124 | 6.6% |
| r | 371816 | 6.0% |
| l | 274085 | 4.4% |
| n | 273627 | 4.4% |
| t | 260673 | 4.2% |
| i | 258528 | 4.2% |
| s | 241579 | 3.9% |
| Other values (59) | 2416482 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6191576 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 693319 | 11.2% | |
| e | 502694 | 8.1% |
| o | 487649 | 7.9% |
| a | 411124 | 6.6% |
| r | 371816 | 6.0% |
| l | 274085 | 4.4% |
| n | 273627 | 4.4% |
| t | 260673 | 4.2% |
| i | 258528 | 4.2% |
| s | 241579 | 3.9% |
| Other values (59) | 2416482 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6191576 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 693319 | 11.2% | |
| e | 502694 | 8.1% |
| o | 487649 | 7.9% |
| a | 411124 | 6.6% |
| r | 371816 | 6.0% |
| l | 274085 | 4.4% |
| n | 273627 | 4.4% |
| t | 260673 | 4.2% |
| i | 258528 | 4.2% |
| s | 241579 | 3.9% |
| Other values (59) | 2416482 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6191576 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 693319 | 11.2% | |
| e | 502694 | 8.1% |
| o | 487649 | 7.9% |
| a | 411124 | 6.6% |
| r | 371816 | 6.0% |
| l | 274085 | 4.4% |
| n | 273627 | 4.4% |
| t | 260673 | 4.2% |
| i | 258528 | 4.2% |
| s | 241579 | 3.9% |
| Other values (59) | 2416482 |
dealer_zip
Real number (ℝ)
MISSING 
| Distinct | 575 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 2693 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59744.542 |
| Minimum | 1020 |
|---|---|
| Maximum | 99301 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 1020 |
|---|---|
| 5-th percentile | 60004 |
| Q1 | 60126 |
| median | 60445 |
| Q3 | 60532 |
| 95-th percentile | 60659 |
| Maximum | 99301 |
| Range | 98281 |
| Interquartile range (IQR) | 406 |
Descriptive statistics
| Standard deviation | 3193.3773 |
|---|---|
| Coefficient of variation (CV) | 0.053450527 |
| Kurtosis | 44.540649 |
| Mean | 59744.542 |
| Median Absolute Deviation (MAD) | 197 |
| Skewness | -4.7385917 |
| Sum | 1.543094 × 1010 |
| Variance | 10197658 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 60540 | 16462 | 6.3% |
| 60515 | 12635 | 4.8% |
| 60525 | 9819 | 3.8% |
| 60126 | 8535 | 3.3% |
| 46322 | 7586 | 2.9% |
| 60453 | 7027 | 2.7% |
| 60035 | 6877 | 2.6% |
| 60477 | 6856 | 2.6% |
| 60559 | 6793 | 2.6% |
| 60462 | 5902 | 2.3% |
| Other values (565) | 169790 |
| Value | Count | Frequency (%) |
| 1020 | 3 | |
| 1060 | 3 | |
| 1201 | 1 | < 0.1% |
| 2135 | 1 | < 0.1% |
| 2601 | 2 | |
| 2717 | 1 | < 0.1% |
| 2886 | 1 | < 0.1% |
| 2891 | 1 | < 0.1% |
| 3060 | 1 | < 0.1% |
| 3103 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 99301 | 1 | |
| 99201 | 2 | |
| 99019 | 1 | |
| 98837 | 1 | |
| 98037 | 1 | |
| 98036 | 1 | |
| 97702 | 1 | |
| 97401 | 1 | |
| 97225 | 1 | |
| 97005 | 2 |
mileage
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 38534 |
|---|---|
| Distinct (%) | 15.1% |
| Missing | 5943 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30231.074 |
| Minimum | 0 |
|---|---|
| Maximum | 962839 |
| Zeros | 10145 |
| Zeros (%) | 3.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 7 |
| median | 4197 |
| Q3 | 51569 |
| 95-th percentile | 118540.25 |
| Maximum | 962839 |
| Range | 962839 |
| Interquartile range (IQR) | 51562 |
Descriptive statistics
| Standard deviation | 42813.013 |
|---|---|
| Coefficient of variation (CV) | 1.4161923 |
| Kurtosis | 3.9326183 |
| Mean | 30231.074 |
| Median Absolute Deviation (MAD) | 4197 |
| Skewness | 1.697265 |
| Sum | 7.7098913 × 109 |
| Variance | 1.8329541 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 16127 | 6.2% |
| 10 | 15735 | 6.0% |
| 0 | 10145 | 3.9% |
| 3 | 9056 | 3.5% |
| 6 | 8519 | 3.3% |
| 2 | 6694 | 2.6% |
| 7 | 5760 | 2.2% |
| 1 | 5549 | 2.1% |
| 11 | 5401 | 2.1% |
| 4 | 4858 | 1.9% |
| Other values (38524) | 167188 | |
| (Missing) | 5943 | 2.3% |
| Value | Count | Frequency (%) |
| 0 | 10145 | |
| 1 | 5549 | 2.1% |
| 2 | 6694 | |
| 3 | 9056 | |
| 4 | 4858 | 1.9% |
| 5 | 16127 | |
| 6 | 8519 | |
| 7 | 5760 | 2.2% |
| 8 | 3931 | 1.5% |
| 9 | 3802 | 1.5% |
| Value | Count | Frequency (%) |
| 962839 | 1 | < 0.1% |
| 440911 | 2 | < 0.1% |
| 426586 | 3 | < 0.1% |
| 403877 | 4 | < 0.1% |
| 398677 | 3 | < 0.1% |
| 385223 | 10 | |
| 376000 | 1 | < 0.1% |
| 358331 | 2 | < 0.1% |
| 350017 | 5 | |
| 344541 | 1 | < 0.1% |
make
Text
| Distinct | 66 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 6.2382987 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1628040 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Chevrolet |
|---|---|
| 2nd row | RAM |
| 3rd row | Mercedes-Benz |
| 4th row | Honda |
| 5th row | Chevrolet |
| Value | Count | Frequency (%) |
| ford | 25474 | 9.6% |
| chevrolet | 22427 | 8.5% |
| mercedes-benz | 17235 | 6.5% |
| jeep | 16495 | 6.2% |
| bmw | 14963 | 5.6% |
| nissan | 14876 | 5.6% |
| hyundai | 12647 | 4.8% |
| volkswagen | 11681 | 4.4% |
| audi | 9469 | 3.6% |
| honda | 8662 | 3.3% |
| Other values (60) | 111460 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 188957 | 11.6% |
| a | 120402 | 7.4% |
| o | 112268 | 6.9% |
| d | 97449 | 6.0% |
| r | 96956 | 6.0% |
| n | 81112 | 5.0% |
| s | 78461 | 4.8% |
| i | 69504 | 4.3% |
| l | 62983 | 3.9% |
| u | 57513 | 3.5% |
| Other values (37) | 662435 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1628040 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 188957 | 11.6% |
| a | 120402 | 7.4% |
| o | 112268 | 6.9% |
| d | 97449 | 6.0% |
| r | 96956 | 6.0% |
| n | 81112 | 5.0% |
| s | 78461 | 4.8% |
| i | 69504 | 4.3% |
| l | 62983 | 3.9% |
| u | 57513 | 3.5% |
| Other values (37) | 662435 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1628040 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 188957 | 11.6% |
| a | 120402 | 7.4% |
| o | 112268 | 6.9% |
| d | 97449 | 6.0% |
| r | 96956 | 6.0% |
| n | 81112 | 5.0% |
| s | 78461 | 4.8% |
| i | 69504 | 4.3% |
| l | 62983 | 3.9% |
| u | 57513 | 3.5% |
| Other values (37) | 662435 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1628040 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 188957 | 11.6% |
| a | 120402 | 7.4% |
| o | 112268 | 6.9% |
| d | 97449 | 6.0% |
| r | 96956 | 6.0% |
| n | 81112 | 5.0% |
| s | 78461 | 4.8% |
| i | 69504 | 4.3% |
| l | 62983 | 3.9% |
| u | 57513 | 3.5% |
| Other values (37) | 662435 |
bodystyle
Categorical
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1263 |
| Missing (%) | 0.5% |
| Memory size | 4.0 MiB |
| SUV | |
|---|---|
| Sedan | |
| Pickup Truck | |
| Coupe | 12193 |
| Cargo Van | 10531 |
| Other values (5) |
Length
| Max length | 13 |
|---|---|
| Median length | 3 |
| Mean length | 5.0603091 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1314223 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SUV |
|---|---|
| 2nd row | Cargo Van |
| 3rd row | Cargo Van |
| 4th row | SUV |
| 5th row | SUV |
Common Values
| Value | Count | Frequency (%) |
| SUV | 145431 | |
| Sedan | 45761 | 17.5% |
| Pickup Truck | 21495 | 8.2% |
| Coupe | 12193 | 4.7% |
| Cargo Van | 10531 | 4.0% |
| Hatchback | 9301 | 3.6% |
| Convertible | 8325 | 3.2% |
| Passenger Van | 3028 | 1.2% |
| Wagon | 2368 | 0.9% |
| Minivan | 1279 | 0.5% |
| (Missing) | 1263 | 0.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| suv | 145431 | |
| sedan | 45761 | 15.5% |
| pickup | 21495 | 7.3% |
| truck | 21495 | 7.3% |
| van | 13559 | 4.6% |
| coupe | 12193 | 4.1% |
| cargo | 10531 | 3.6% |
| hatchback | 9301 | 3.2% |
| convertible | 8325 | 2.8% |
| passenger | 3028 | 1.0% |
| Other values (2) | 3647 | 1.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 191192 | |
| V | 158990 | |
| U | 145431 | |
| a | 95128 | 7.2% |
| e | 80660 | 6.1% |
| n | 75599 | 5.8% |
| c | 61592 | 4.7% |
| u | 55183 | 4.2% |
| k | 52291 | 4.0% |
| d | 45761 | 3.5% |
| Other values (18) | 352396 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1314223 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 191192 | |
| V | 158990 | |
| U | 145431 | |
| a | 95128 | 7.2% |
| e | 80660 | 6.1% |
| n | 75599 | 5.8% |
| c | 61592 | 4.7% |
| u | 55183 | 4.2% |
| k | 52291 | 4.0% |
| d | 45761 | 3.5% |
| Other values (18) | 352396 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1314223 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 191192 | |
| V | 158990 | |
| U | 145431 | |
| a | 95128 | 7.2% |
| e | 80660 | 6.1% |
| n | 75599 | 5.8% |
| c | 61592 | 4.7% |
| u | 55183 | 4.2% |
| k | 52291 | 4.0% |
| d | 45761 | 3.5% |
| Other values (18) | 352396 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1314223 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 191192 | |
| V | 158990 | |
| U | 145431 | |
| a | 95128 | 7.2% |
| e | 80660 | 6.1% |
| n | 75599 | 5.8% |
| c | 61592 | 4.7% |
| u | 55183 | 4.2% |
| k | 52291 | 4.0% |
| d | 45761 | 3.5% |
| Other values (18) | 352396 |
cat
Categorical
MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4057 |
| Missing (%) | 1.6% |
| Memory size | 4.0 MiB |
| crossover_compact | |
|---|---|
| luxurysuv_crossover | |
| crossover_midsize | |
| suv_midsize | |
| truck_fullsize | |
| Other values (34) |
Length
| Max length | 28 |
|---|---|
| Median length | 24 |
| Mean length | 16.542753 |
| Min length | 8 |
Characters and Unicode
| Total characters | 4250131 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ev_crossover_midsize |
|---|---|
| 2nd row | van_fullsize |
| 3rd row | van_fullsize |
| 4th row | crossover_compact |
| 5th row | crossover_midsize |
Common Values
| Value | Count | Frequency (%) |
| crossover_compact | 44405 | |
| luxurysuv_crossover | 33734 | |
| crossover_midsize | 20780 | 8.0% |
| suv_midsize | 17082 | 6.5% |
| truck_fullsize | 15057 | 5.8% |
| luxurypassenger_standard | 13441 | 5.2% |
| van_fullsize | 12391 | 4.7% |
| sedan_compact | 12185 | 4.7% |
| sedan_midsize | 9878 | 3.8% |
| luxurypassenger_plus | 9602 | 3.7% |
| Other values (29) | 68363 |
Length
| Value | Count | Frequency (%) |
| crossover_compact | 44405 | |
| luxurysuv_crossover | 33734 | |
| crossover_midsize | 20780 | 8.1% |
| suv_midsize | 17082 | 6.6% |
| truck_fullsize | 15057 | 5.9% |
| luxurypassenger_standard | 13441 | 5.2% |
| van_fullsize | 12391 | 4.8% |
| sedan_compact | 12185 | 4.7% |
| sedan_midsize | 9878 | 3.8% |
| luxurypassenger_plus | 9602 | 3.7% |
| Other values (29) | 68363 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 499915 | |
| r | 379911 | 8.9% |
| e | 339142 | 8.0% |
| o | 316501 | 7.4% |
| u | 311246 | 7.3% |
| c | 307441 | 7.2% |
| _ | 270578 | 6.4% |
| v | 232436 | 5.5% |
| a | 202514 | 4.8% |
| i | 175570 | 4.1% |
| Other values (15) | 1214877 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4250131 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 499915 | |
| r | 379911 | 8.9% |
| e | 339142 | 8.0% |
| o | 316501 | 7.4% |
| u | 311246 | 7.3% |
| c | 307441 | 7.2% |
| _ | 270578 | 6.4% |
| v | 232436 | 5.5% |
| a | 202514 | 4.8% |
| i | 175570 | 4.1% |
| Other values (15) | 1214877 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4250131 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 499915 | |
| r | 379911 | 8.9% |
| e | 339142 | 8.0% |
| o | 316501 | 7.4% |
| u | 311246 | 7.3% |
| c | 307441 | 7.2% |
| _ | 270578 | 6.4% |
| v | 232436 | 5.5% |
| a | 202514 | 4.8% |
| i | 175570 | 4.1% |
| Other values (15) | 1214877 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4250131 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 499915 | |
| r | 379911 | 8.9% |
| e | 339142 | 8.0% |
| o | 316501 | 7.4% |
| u | 311246 | 7.3% |
| c | 307441 | 7.2% |
| _ | 270578 | 6.4% |
| v | 232436 | 5.5% |
| a | 202514 | 4.8% |
| i | 175570 | 4.1% |
| Other values (15) | 1214877 |
vin
Text
| Distinct | 89244 |
|---|---|
| Distinct (%) | 34.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 16.991911 |
| Min length | 7 |
Characters and Unicode
| Total characters | 4434464 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 30351 ? |
|---|---|
| Unique (%) | 11.6% |
Sample
| 1st row | 3GNKDCRJ6RS227894 |
|---|---|
| 2nd row | 3C6LRVDG0RE118763 |
| 3rd row | W1Y4KCHY8RT178723 |
| 4th row | 5J6RS3H44RL004214 |
| 5th row | 3GNAXHEG1RL299011 |
| Value | Count | Frequency (%) |
| scedt26t9bd002935 | 40 | < 0.1% |
| 1g6kw5rj0lu103290 | 39 | < 0.1% |
| sbm13gaa0jw005233 | 38 | < 0.1% |
| wba7j2c57jg938534 | 38 | < 0.1% |
| scfac23363b500753 | 38 | < 0.1% |
| zffkc33c000083652 | 38 | < 0.1% |
| sbm16aea7pw001459 | 38 | < 0.1% |
| 2ckdl43f686065575 | 38 | < 0.1% |
| wbaeg2324pcb74981 | 38 | < 0.1% |
| sbm11raa1gw675304 | 37 | < 0.1% |
| Other values (89234) | 260593 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 364226 | 8.2% |
| 3 | 267112 | 6.0% |
| 0 | 260071 | 5.9% |
| 2 | 255802 | 5.8% |
| 4 | 246164 | 5.6% |
| 5 | 245138 | 5.5% |
| 7 | 201173 | 4.5% |
| 6 | 198119 | 4.5% |
| 8 | 192992 | 4.4% |
| R | 185508 | 4.2% |
| Other values (26) | 2018159 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4434464 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 364226 | 8.2% |
| 3 | 267112 | 6.0% |
| 0 | 260071 | 5.9% |
| 2 | 255802 | 5.8% |
| 4 | 246164 | 5.6% |
| 5 | 245138 | 5.5% |
| 7 | 201173 | 4.5% |
| 6 | 198119 | 4.5% |
| 8 | 192992 | 4.4% |
| R | 185508 | 4.2% |
| Other values (26) | 2018159 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4434464 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 364226 | 8.2% |
| 3 | 267112 | 6.0% |
| 0 | 260071 | 5.9% |
| 2 | 255802 | 5.8% |
| 4 | 246164 | 5.6% |
| 5 | 245138 | 5.5% |
| 7 | 201173 | 4.5% |
| 6 | 198119 | 4.5% |
| 8 | 192992 | 4.4% |
| R | 185508 | 4.2% |
| Other values (26) | 2018159 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4434464 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 364226 | 8.2% |
| 3 | 267112 | 6.0% |
| 0 | 260071 | 5.9% |
| 2 | 255802 | 5.8% |
| 4 | 246164 | 5.6% |
| 5 | 245138 | 5.5% |
| 7 | 201173 | 4.5% |
| 6 | 198119 | 4.5% |
| 8 | 192992 | 4.4% |
| R | 185508 | 4.2% |
| Other values (26) | 2018159 |
canonical_mmt
Text
| Distinct | 6979 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
Length
| Max length | 97 |
|---|---|
| Median length | 87 |
| Mean length | 23.227248 |
| Min length | 6 |
Characters and Unicode
| Total characters | 6061731 |
|---|---|
| Distinct characters | 81 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 797 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | Chevrolet:Blazer EV:RS |
|---|---|
| 2nd row | RAM:ProMaster 2500:High Roof |
| 3rd row | Mercedes-Benz:Sprinter 2500:High Roof |
| 4th row | Honda:CR-V:EX |
| 5th row | Chevrolet:Equinox:LS |
| Value | Count | Frequency (%) |
| s | 8120 | 1.6% |
| premium | 8074 | 1.6% |
| plus | 6916 | 1.4% |
| 4matic | 6783 | 1.3% |
| jeep:grand | 6340 | 1.3% |
| se | 6206 | 1.2% |
| roof | 5558 | 1.1% |
| package | 4030 | 0.8% |
| chevrolet:silverado | 3925 | 0.8% |
| awd | 3845 | 0.8% |
| Other values (5476) | 447281 |
Most occurring characters
| Value | Count | Frequency (%) |
| : | 521953 | 8.6% |
| e | 482194 | 8.0% |
| a | 350510 | 5.8% |
| r | 337781 | 5.6% |
| o | 273351 | 4.5% |
| i | 261702 | 4.3% |
| 245589 | 4.1% | |
| n | 213922 | 3.5% |
| s | 193953 | 3.2% |
| d | 171756 | 2.8% |
| Other values (71) | 3009020 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6061731 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| : | 521953 | 8.6% |
| e | 482194 | 8.0% |
| a | 350510 | 5.8% |
| r | 337781 | 5.6% |
| o | 273351 | 4.5% |
| i | 261702 | 4.3% |
| 245589 | 4.1% | |
| n | 213922 | 3.5% |
| s | 193953 | 3.2% |
| d | 171756 | 2.8% |
| Other values (71) | 3009020 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6061731 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| : | 521953 | 8.6% |
| e | 482194 | 8.0% |
| a | 350510 | 5.8% |
| r | 337781 | 5.6% |
| o | 273351 | 4.5% |
| i | 261702 | 4.3% |
| 245589 | 4.1% | |
| n | 213922 | 3.5% |
| s | 193953 | 3.2% |
| d | 171756 | 2.8% |
| Other values (71) | 3009020 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6061731 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| : | 521953 | 8.6% |
| e | 482194 | 8.0% |
| a | 350510 | 5.8% |
| r | 337781 | 5.6% |
| o | 273351 | 4.5% |
| i | 261702 | 4.3% |
| 245589 | 4.1% | |
| n | 213922 | 3.5% |
| s | 193953 | 3.2% |
| d | 171756 | 2.8% |
| Other values (71) | 3009020 |
fuel_type
Categorical
IMBALANCE 
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2232 |
| Missing (%) | 0.9% |
| Memory size | 4.0 MiB |
| Gasoline | |
|---|---|
| Electric | 14128 |
| Hybrid | 11297 |
| Diesel | 6930 |
| E85 Flex Fuel | 3666 |
| Other values (19) | 515 |
Length
| Max length | 29 |
|---|---|
| Median length | 8 |
| Mean length | 7.9466923 |
| Min length | 6 |
Characters and Unicode
| Total characters | 2056151 |
|---|---|
| Distinct characters | 42 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Electric |
|---|---|
| 2nd row | Gasoline |
| 3rd row | Diesel |
| 4th row | Gasoline |
| 5th row | Gasoline |
Common Values
| Value | Count | Frequency (%) |
| Gasoline | 222207 | |
| Electric | 14128 | 5.4% |
| Hybrid | 11297 | 4.3% |
| Diesel | 6930 | 2.7% |
| E85 Flex Fuel | 3666 | 1.4% |
| Plug-In Hybrid | 103 | < 0.1% |
| Regular Unleaded | 62 | < 0.1% |
| Gasoline/Mild Electric Hy | 58 | < 0.1% |
| Electric and Gas Hybrid | 46 | < 0.1% |
| Bio Diesel | 38 | < 0.1% |
| Other values (14) | 208 | 0.1% |
| (Missing) | 2232 | 0.9% |
Length
| Value | Count | Frequency (%) |
| gasoline | 222237 | |
| electric | 14278 | 5.4% |
| hybrid | 11460 | 4.3% |
| diesel | 6981 | 2.6% |
| fuel | 3736 | 1.4% |
| flex | 3667 | 1.4% |
| e85 | 3666 | 1.4% |
| plug-in | 108 | < 0.1% |
| unleaded | 89 | < 0.1% |
| gasoline/mild | 69 | < 0.1% |
| Other values (18) | 497 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 258334 | |
| i | 255275 | |
| l | 251409 | |
| s | 229390 | |
| a | 222680 | |
| n | 222556 | |
| G | 222433 | |
| o | 222348 | |
| c | 28630 | 1.4% |
| r | 25864 | 1.3% |
| Other values (32) | 117232 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2056151 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 258334 | |
| i | 255275 | |
| l | 251409 | |
| s | 229390 | |
| a | 222680 | |
| n | 222556 | |
| G | 222433 | |
| o | 222348 | |
| c | 28630 | 1.4% |
| r | 25864 | 1.3% |
| Other values (32) | 117232 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2056151 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 258334 | |
| i | 255275 | |
| l | 251409 | |
| s | 229390 | |
| a | 222680 | |
| n | 222556 | |
| G | 222433 | |
| o | 222348 | |
| c | 28630 | 1.4% |
| r | 25864 | 1.3% |
| Other values (32) | 117232 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2056151 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 258334 | |
| i | 255275 | |
| l | 251409 | |
| s | 229390 | |
| a | 222680 | |
| n | 222556 | |
| G | 222433 | |
| o | 222348 | |
| c | 28630 | 1.4% |
| r | 25864 | 1.3% |
| Other values (32) | 117232 |
stock_type
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| Used | |
|---|---|
| New |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.5148654 |
| Min length | 3 |
Characters and Unicode
| Total characters | 917292 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New |
|---|---|
| 2nd row | New |
| 3rd row | New |
| 4th row | New |
| 5th row | New |
Common Values
| Value | Count | Frequency (%) |
| Used | 134367 | |
| New | 126608 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| used | 134367 | |
| new | 126608 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 260975 | |
| U | 134367 | |
| s | 134367 | |
| d | 134367 | |
| N | 126608 | |
| w | 126608 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 917292 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 260975 | |
| U | 134367 | |
| s | 134367 | |
| d | 134367 | |
| N | 126608 | |
| w | 126608 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 917292 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 260975 | |
| U | 134367 | |
| s | 134367 | |
| d | 134367 | |
| N | 126608 | |
| w | 126608 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 917292 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 260975 | |
| U | 134367 | |
| s | 134367 | |
| d | 134367 | |
| N | 126608 | |
| w | 126608 |
exterior_color
Text
MISSING 
| Distinct | 3927 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 3285 |
| Missing (%) | 1.3% |
| Memory size | 4.0 MiB |
Length
| Max length | 54 |
|---|---|
| Median length | 46 |
| Mean length | 15.053425 |
| Min length | 1 |
Characters and Unicode
| Total characters | 3879117 |
|---|---|
| Distinct characters | 78 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 533 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | Sterling Gray Metallic |
|---|---|
| 2nd row | Bright White Clearcoat |
| 3rd row | Blue Grey |
| 4th row | Radiant Red Metallic |
| 5th row | Summit White |
| Value | Count | Frequency (%) |
| metallic | 79920 | 13.4% |
| white | 62514 | 10.5% |
| black | 58825 | 9.9% |
| gray | 33983 | 5.7% |
| blue | 22334 | 3.7% |
| silver | 22093 | 3.7% |
| pearl | 21817 | 3.7% |
| clearcoat | 18456 | 3.1% |
| red | 15708 | 2.6% |
| crystal | 11669 | 2.0% |
| Other values (1813) | 249099 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 384301 | 9.9% |
| a | 371242 | 9.6% |
| e | 367120 | 9.5% |
| 338741 | 8.7% | |
| i | 301201 | 7.8% |
| t | 285091 | 7.3% |
| r | 216862 | 5.6% |
| c | 205392 | 5.3% |
| M | 103580 | 2.7% |
| B | 102099 | 2.6% |
| Other values (68) | 1203488 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3879117 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 384301 | 9.9% |
| a | 371242 | 9.6% |
| e | 367120 | 9.5% |
| 338741 | 8.7% | |
| i | 301201 | 7.8% |
| t | 285091 | 7.3% |
| r | 216862 | 5.6% |
| c | 205392 | 5.3% |
| M | 103580 | 2.7% |
| B | 102099 | 2.6% |
| Other values (68) | 1203488 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3879117 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 384301 | 9.9% |
| a | 371242 | 9.6% |
| e | 367120 | 9.5% |
| 338741 | 8.7% | |
| i | 301201 | 7.8% |
| t | 285091 | 7.3% |
| r | 216862 | 5.6% |
| c | 205392 | 5.3% |
| M | 103580 | 2.7% |
| B | 102099 | 2.6% |
| Other values (68) | 1203488 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3879117 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 384301 | 9.9% |
| a | 371242 | 9.6% |
| e | 367120 | 9.5% |
| 338741 | 8.7% | |
| i | 301201 | 7.8% |
| t | 285091 | 7.3% |
| r | 216862 | 5.6% |
| c | 205392 | 5.3% |
| M | 103580 | 2.7% |
| B | 102099 | 2.6% |
| Other values (68) | 1203488 |
page_channel
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| shopping |
|---|
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 2087800 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | shopping |
|---|---|
| 2nd row | shopping |
| 3rd row | shopping |
| 4th row | shopping |
| 5th row | shopping |
Common Values
| Value | Count | Frequency (%) |
| shopping | 260975 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| shopping | 260975 |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 521950 | |
| s | 260975 | |
| h | 260975 | |
| o | 260975 | |
| i | 260975 | |
| n | 260975 | |
| g | 260975 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2087800 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| p | 521950 | |
| s | 260975 | |
| h | 260975 | |
| o | 260975 | |
| i | 260975 | |
| n | 260975 | |
| g | 260975 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2087800 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| p | 521950 | |
| s | 260975 | |
| h | 260975 | |
| o | 260975 | |
| i | 260975 | |
| n | 260975 | |
| g | 260975 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2087800 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| p | 521950 | |
| s | 260975 | |
| h | 260975 | |
| o | 260975 | |
| i | 260975 | |
| n | 260975 | |
| g | 260975 |
| listing_id | msrp | year | canonical_mmty | model | local_zone | interior_color | aff_code | price | price_badge | trim | drivetrain | dealer_name | dealer_zip | mileage | make | bodystyle | cat | vin | canonical_mmt | fuel_type | stock_type | exterior_color | page_channel | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2f77722f-3a80-4960-bd04-4859b4df975e | 57215.0 | 2024 | Chevrolet:Blazer EV:RS:2024 | Blazer EV | NaN | Black | national | 54595.0 | NaN | RS | All-wheel Drive | Castle Rock Chevrolet GMC | 80104.0 | 0.0 | Chevrolet | SUV | ev_crossover_midsize | 3GNKDCRJ6RS227894 | Chevrolet:Blazer EV:RS | Electric | New | Sterling Gray Metallic | shopping |
| 1 | 067f9671-3672-4d0a-afe8-110b905bed3a | 58845.0 | 2024 | RAM:ProMaster 2500:High Roof:2024 | ProMaster 2500 | NaN | Black | national | 52446.0 | NaN | High Roof | Front-wheel Drive | New Smyrna Chrysler Jeep Dodge RAM | 32168.0 | 0.0 | RAM | Cargo Van | van_fullsize | 3C6LRVDG0RE118763 | RAM:ProMaster 2500:High Roof | Gasoline | New | Bright White Clearcoat | shopping |
| 2 | 0a24aeeb-112c-4a6f-b932-07504e82dacb | 58795.0 | 2024 | Mercedes-Benz:Sprinter 2500:High Roof:2024 | Sprinter 2500 | NaN | NaN | national | 54295.0 | NaN | High Roof | Rear-wheel Drive | Mercedes-Benz of Farmington | 84025.0 | 8.0 | Mercedes-Benz | Cargo Van | van_fullsize | W1Y4KCHY8RT178723 | Mercedes-Benz:Sprinter 2500:High Roof | Diesel | New | Blue Grey | shopping |
| 3 | 2636cae0-4081-4ce3-8940-5687e8ada129 | 33815.0 | 2024 | Honda:CR-V:EX:2024 | CR-V | NaN | Gray | national | NaN | NaN | EX | Front-wheel Drive | Kingman Honda | 86409.0 | 7.0 | Honda | SUV | crossover_compact | 5J6RS3H44RL004214 | Honda:CR-V:EX | Gasoline | New | Radiant Red Metallic | shopping |
| 4 | b443a216-8ea4-4e1c-b5f3-a6210d6f95e9 | 27995.0 | 2024 | Chevrolet:Equinox:LS:2024 | Equinox | NaN | Medium Ash Gray | national | 24803.0 | NaN | LS | Front-wheel Drive | McSweeney Chevrolet GMC Clanton | 35045.0 | 0.0 | Chevrolet | SUV | crossover_midsize | 3GNAXHEG1RL299011 | Chevrolet:Equinox:LS | Gasoline | New | Summit White | shopping |
| 5 | 9d076ff4-8598-43fa-9dda-0b29e82df839 | 83630.0 | 2024 | Audi:Q8 e-tron:Premium:2024 | Q8 e-tron | NaN | Pearl Beige | national | 83630.0 | NaN | Premium | All-wheel Drive | Audi Stuart | 34997.0 | 20.0 | Audi | SUV | ev_crossover_midsize | WA15AAGE4RB021424 | Audi:Q8 e-tron:Premium | Electric | New | Glacier White Metallic | shopping |
| 6 | 3110196b-8104-49f9-a176-7f1de500ffde | 33610.0 | 2024 | Mitsubishi:Eclipse Cross:SEL:2024 | Eclipse Cross | NaN | Gray | national | 33610.0 | NaN | SEL | Four-wheel Drive | McClinton Auto Group | 26101.0 | 5.0 | Mitsubishi | SUV | crossover_compact | JA4ATWAA2RZ046423 | Mitsubishi:Eclipse Cross:SEL | Gasoline | New | Mercury Gray Metallic | shopping |
| 7 | c08081b6-68fa-4820-b5ff-b53730a64809 | 50185.0 | 2024 | Dodge:Hornet:R/T Plus:2024 | Hornet | NaN | Black | national | 40185.0 | NaN | R/T Plus | All-wheel Drive | Don Jackson CDJR North | 30028.0 | 16.0 | Dodge | SUV | hybrid_suv | ZACPDFDW9R3A24025 | Dodge:Hornet:R/T Plus | Hybrid | New | Blue Steel | shopping |
| 8 | 19e8d9c0-6f63-4700-84fd-60ca232502e4 | 27825.0 | 2024 | Nissan:Kicks:SR:2024 | Kicks | NaN | Charcoal | national | 27825.0 | NaN | SR | Front-wheel Drive | Halladay Nissan | 82001.0 | 6.0 | Nissan | SUV | crossover_compact | 3N1CP5DV6RL526633 | Nissan:Kicks:SR | Gasoline | New | Scarlet Ember Tintcoat | shopping |
| 9 | c2df0bf7-c206-4f9e-bd34-4410aabde5f9 | 53727.0 | 2024 | Volkswagen:Atlas Cross Sport:2.0T SEL Premium R-Line:2024 | Atlas Cross Sport | NaN | Black w/ Blue Crust | national | 50727.0 | NaN | 2.0T SEL Premium R-Line | All-wheel Drive | AutoNation Volkswagen Las Vegas | 89146.0 | 10.0 | Volkswagen | SUV | suv_midsize | 1V2FE2CA0RC238064 | Volkswagen:Atlas Cross Sport:2.0T SEL Premium R-Line | Gasoline | New | Platinum Gray Metallic | shopping |
| listing_id | msrp | year | canonical_mmty | model | local_zone | interior_color | aff_code | price | price_badge | trim | drivetrain | dealer_name | dealer_zip | mileage | make | bodystyle | cat | vin | canonical_mmt | fuel_type | stock_type | exterior_color | page_channel | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 260965 | efe10bbf-9fbf-42ab-9e96-a09c5e699179 | 0.0 | 2016 | Cadillac:XTS:Luxury:2016 | XTS | NaN | Jet Black | national | 15450.0 | NaN | Luxury | All-wheel Drive | Revved Motors | 60101.0 | 97580.0 | Cadillac | Sedan | luxurypassenger_plus | 2G61N5S35G9114248 | Cadillac:XTS:Luxury | Gasoline | Used | Summit White | shopping |
| 260966 | a376ed8b-a7ad-43a4-b6c1-bc7ab99269d6 | 49700.0 | 2024 | Jeep:Grand Cherokee:Limited X:2024 | Grand Cherokee | NaN | B6x7 | national | 42386.0 | NaN | Limited X | Four-wheel Drive | Castle Chrysler Dodge Jeep Ram of Naperville | 60540.0 | 10.0 | Jeep | SUV | suv_midsize | 1C4RJHBG2RC165945 | Jeep:Grand Cherokee:Limited X | Gasoline | New | Bright White Clearcoat | shopping |
| 260967 | 82c83ed9-ecc2-4d9d-8ae3-44b436d06f8a | 0.0 | 2014 | Chevrolet:Traverse:1LT:2014 | Traverse | NaN | Ebony | national | 11975.0 | NaN | 1LT | Front-wheel Drive | Arlington Heights Buick GMC | 60004.0 | 99098.0 | Chevrolet | SUV | crossover_midsize | 1GNKRGKD7EJ367803 | Chevrolet:Traverse:1LT | Gasoline | Used | White Diamond Tricoat | shopping |
| 260968 | 3b2ee8c5-aea6-4aca-a0ba-5f8429bbc8fd | 35505.0 | 2024 | Ford:Bronco Sport:Big Bend:2024 | Bronco Sport | NaN | Ebony | national | 31813.0 | NaN | Big Bend | Four-wheel Drive | Napleton Ford of Oak Lawn | 60453.0 | 8.0 | Ford | SUV | crossover_compact | 3FMCR9B62RRE31084 | Ford:Bronco Sport:Big Bend | Gasoline | New | Shadow Black | shopping |
| 260969 | 8135e3ea-77bc-43ac-bb72-f3605ae50deb | 38320.0 | 2024 | Ford:Bronco Sport:Outer Banks:2024 | Bronco Sport | NaN | Ebony/Roast | national | 35319.0 | NaN | Outer Banks | Four-wheel Drive | Fox Lincoln | 60647.0 | 2.0 | Ford | SUV | crossover_compact | 3FMCR9C6XRRF18701 | Ford:Bronco Sport:Outer Banks | Gasoline | New | Eruption Green Metallic | shopping |
| 260970 | 6c208dd2-2b2d-4ecb-b28d-c18277d23b4f | 35655.0 | 2025 | Honda:CR-V:EX:2025 | CR-V | NaN | Gray | national | 34044.0 | NaN | EX | All-wheel Drive | Napleton Honda of Morton Grove | 60053.0 | 13.0 | Honda | SUV | crossover_compact | 7FARS4H4XSE007367 | Honda:CR-V:EX | Gasoline | New | Platinum White Pearl | shopping |
| 260971 | 02f5a064-6abb-48dc-baf3-fcf5e59bad7a | 0.0 | 2023 | Genesis:G70:2.0T AWD:2023 | G70 | NaN | Obsidian Black/Red Stitch | national | 43498.0 | NaN | 2.0T AWD | All-wheel Drive | Genesis of Schaumburg | 60173.0 | 1298.0 | Genesis | Sedan | luxurypassenger_standard | KMTG34TAXPU134326 | Genesis:G70:2.0T AWD | Gasoline | Used | Uyuni White | shopping |
| 260972 | 6b7d71a7-47d4-40f8-98b6-e900647da6e8 | 0.0 | 2018 | Audi:SQ5:3.0T Premium Plus:2018 | SQ5 | NaN | Black Quilted Leather | national | 36850.0 | NaN | 3.0T Premium Plus | All-wheel Drive | Windy City Motors | 60639.0 | 68387.0 | Audi | SUV | luxurysuv_crossover | WA1A4AFY6J2025206 | Audi:SQ5:3.0T Premium Plus | Gasoline | Used | Florett Silver Metallic | shopping |
| 260973 | ae34d3b9-1857-4d40-8cff-cd6f446c39b4 | 52810.0 | 2024 | Jeep:Grand Cherokee:Limited X:2024 | Grand Cherokee | NaN | Capri Leathereete Seats | national | 44310.0 | NaN | Limited X | Four-wheel Drive | Marino Chrysler Jeep Dodge RAM | 60641.0 | 0.0 | Jeep | SUV | suv_midsize | 1C4RJHBG7RC159641 | Jeep:Grand Cherokee:Limited X | Gasoline | New | Diamond Black | shopping |
| 260974 | cb9939e1-9a71-4c4d-8931-f9dc4237ede2 | 46904.0 | 2024 | Kia:Sorento:SX:2024 | Sorento | NaN | Black | national | 48415.0 | NaN | SX | All-wheel Drive | International Kia | 60487.0 | 6.0 | Kia | SUV | crossover_midsize | 5XYRKDJF4RG305214 | Kia:Sorento:SX | Gasoline | New | Ebony Black | shopping |
Most frequently occurring
| listing_id | msrp | year | canonical_mmty | model | interior_color | aff_code | price | trim | drivetrain | dealer_name | dealer_zip | mileage | make | bodystyle | cat | vin | canonical_mmt | fuel_type | stock_type | exterior_color | page_channel | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8169 | 2211e8b3-3497-4491-91b8-3e5411022325 | 0.0 | 2010 | Lexus:HS 250h:Premium:2010 | HS 250h | Black | national | 9995.0 | Premium | Front-wheel Drive | Chicago Motors Direct | 60101.0 | 128900.0 | Lexus | Sedan | hybrid_passenger | JTHBB1BA9A2007709 | Lexus:HS 250h:Premium | Hybrid | Used | Black Opal Mica | shopping | 35 |
| 3290 | 0da5d4d7-714c-43d0-9cf7-c0e57895fbf8 | NaN | 1993 | BMW:850:Ci:1993 | 850 | Black | national | 44985.0 | Ci | NaN | Chicago Cars US | 60501.0 | 43506.0 | BMW | Coupe | NaN | WBAEG2324PCB74981 | BMW:850:Ci | Gasoline | Used | Black | shopping | 34 |
| 42598 | b09bd8ed-0547-43fc-b1b7-062cbd1c5854 | 0.0 | 2006 | Mercedes-Benz:R-Class:5.0L:2006 | R-Class | Tan | national | 9999.0 | 5.0L | Four-wheel Drive | My Choice Motors of Elmhurst | 60126.0 | 90021.0 | Mercedes-Benz | NaN | luxurysuv_crossover | 4JGCB75E16A003346 | Mercedes-Benz:R-Class:5.0L | Gasoline | Used | Gold | shopping | 34 |
| 0 | 00030870-19b8-4ead-8e68-9ce0ebfdae4d | NaN | 2006 | Mazda:RX-8:Base:2006 | RX-8 | Black | national | 11495.0 | Base | Rear-wheel Drive | OKAZ MOTORS | 60126.0 | 57950.0 | Mazda | Coupe | coupeconvertible_coupe | JM1FE173360206245 | Mazda:RX-8:Base | Gasoline | Used | Phantom Blue Mica | shopping | 33 |
| 5926 | 18b331f2-b44e-46ce-9eaa-03d580b7d347 | 0.0 | 2019 | Karma:Revero:Sedan:2019 | Revero | Palisades Sport | national | 55800.0 | Sedan | Rear-wheel Drive | Chicago Motor Cars | 60185.0 | 4199.0 | Karma | Sedan | hybrid_passenger | 50GK41SA3KA000129 | Karma:Revero:Sedan | Electric with Ga | Used | Surf White | shopping | 33 |
| 30475 | 7df6bb71-ed0a-4cca-8307-a8948dd43131 | NaN | 2013 | BMW:ActiveHybrid 3:Base:2013 | ActiveHybrid 3 | Black | national | 10985.0 | Base | Rear-wheel Drive | Xchange Motors | 60101.0 | 130268.0 | BMW | Sedan | hybrid_passenger | WBA3F9C52DF145158 | BMW:ActiveHybrid 3:Base | Hybrid | Used | Silver | shopping | 33 |
| 39064 | a1e668bf-4e86-4091-8af6-a7233bf2f708 | NaN | 1989 | Cadillac:Allante::1989 | Allante | Beige | national | 9995.0 | NaN | Front-wheel Drive | Luxury Car Outlet | 60185.0 | 30000.0 | Cadillac | Coupe | NaN | 1G6VR3184KU100277 | Cadillac:Allante: | Gasoline | Used | Red | shopping | 33 |
| 19957 | 52ab2ac9-447b-4721-9d8e-8056b9918275 | 0.0 | 2004 | BMW:745:745i:2004 | 745 | Tan | national | 7999.0 | 745i | Rear-wheel Drive | My Choice Motors of Elmhurst | 60126.0 | 119263.0 | BMW | Sedan | luxurypassenger_plus | WBAGL63424DP69960 | BMW:745:745i | Gasoline | Used | Gold | shopping | 32 |
| 28087 | 73e1caa8-616e-4343-81ef-b3d2a34a136f | 0.0 | 1996 | Chevrolet:Caprice Classic:SS:1996 | Caprice Classic | Gray Leather | national | 69800.0 | SS | Rear-wheel Drive | Chicago Motor Cars | 60185.0 | 5079.0 | Chevrolet | Sedan | NaN | 1G1BL52P2TR154578 | Chevrolet:Caprice Classic:SS | Gasoline | Used | Dark Green Gray Metallic | shopping | 32 |
| 48680 | c97332d8-c3b4-4489-854c-5147c18915e7 | 0.0 | 2006 | Jaguar:X-Type:3.0L AWD 4dr Sedan:2006 | X-Type | Beige | national | 8995.0 | 3.0L AWD 4dr Sedan | All-wheel Drive | Moto Zone Inc. | 60160.0 | 59242.0 | Jaguar | Sedan | luxurypassenger_standard | SAJWA51A66WE98033 | Jaguar:X-Type:3.0L AWD 4dr Sedan | Gasoline | Used | Black | shopping | 32 |